package com.atguigu.gmall.realtime.util;

public class MySqlUtil {


    public static String getBaseDicDDL(){
        String createBaseDicSQL="   CREATE   TABLE base_dic (\n" +
                "               dic_code STRING,\n" +
                "               dic_name STRING,\n" +
                "              PRIMARY KEY (dic_code) NOT ENFORCED\n" +
                "             ) WITH (\n" +
                "               'connector' = 'jdbc',\n" +
                "               'url' = 'jdbc:mysql://hadoop102:3306/gmall',\n" +
                "               'table-name' = 'base_dic',\n" +
                "               'username' = 'root',\n" +
                "               'password' = '000000', \n" +
                "               'lookup.cache.max-rows' ='1000',\n" +
                "               'lookup.cache.ttl' ='60s'\n" +
                "             ) ";
        return createBaseDicSQL;
    }
}
